Views [dbo].[vWorkflowServiceWorkerReport]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created3:38:36 PM Friday, January 07, 2011
Last Modified1:49:41 PM Thursday, September 22, 2011
Columns
Name
WorkflowServiceKey
WorkItemQueueKey
WorkflowInstanceKey
CreatedOn
Category
Priority
Description
EnqueuedOn
PerformerName
SQL Script
CREATE VIEW [dbo].[vWorkflowServiceWorkerReport]
AS
SELECT     wsw.WorkflowServiceKey, wsw.WorkItemQueueKey, wsw.WorkflowInstanceKey, wsw.CreatedOn, wiqr.Category, wiqr.Priority, wiqr.Description,
                      wiqr.EnqueuedOn, wiqr.PerformerName
FROM         dbo.WorkflowServiceWorker wsw INNER JOIN
                      dbo.vWorkItemQueueReport wiqr ON wsw.WorkItemQueueKey = wiqr.WorkItemQueueKey

GO
Uses